package cn.qingyun.gis.modules.express.entity.dto;


import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.data.annotation.Transient;

import java.math.BigDecimal;

/**
 * <p>
 * 快递勘误全部信息返回对象
 * </p>
 *
 * @author miyunguo
 * @since 2023-08-01
 */
@Data
public class ExpressInfoTotalDto {

    @ExcelProperty(value = "id")
    private String id;

    @ExcelProperty(value = "归属省份")
    private String province;

    @ExcelProperty(value = "归属城市")
    private String city;

    @ExcelProperty(value = "归属区县")
    private String districts;

    @ExcelProperty(value = "归属街道")
    private String street;

    @ExcelProperty(value = "归属道路")
    private String road;

    @ExcelProperty(value = "归属门牌号")
    private String streetNumber;

    @ExcelProperty(value = "归属网格")
    private String gridName;

    @ExcelProperty(value = "网格编码")
    private String gridEncoding;
    /*2023080926新增*/
    /**
     * 匹配POI-ID
     */
    @ApiModelProperty(value = "匹配poi-id")
    @Excel(name = "匹配POI-ID", width = 15)
    private String matchPoiId;

    /**
     * 匹配POI名称
     */
    @ApiModelProperty(value = "匹配poi名称")
    @Excel(name = "匹配POI名称", width = 15)
    private String matchPoiName;

    @ApiModelProperty(value = "是否归属本网格(0:不归属,1:归属)")
    @ExcelProperty("是否归属本网格")
    private Integer gridBelongStatus;

    @ApiModelProperty(value = "应属区县")
    @ExcelProperty("应属区县")
    private String belongCounty;

    @ApiModelProperty(value = "应属区县编码")
    @ExcelProperty("应属区县编码")
    private String belongCountyCode;

    @ApiModelProperty(value = "应属网格")
    @ExcelProperty("应属网格")
    private String belongGrid;

    @ApiModelProperty(value = "应属网格编码")
    @ExcelProperty("应属网格编码")
    private String belongGridCode;

    @ExcelProperty(value = "快递名称")
    private String expressName;

    @ExcelProperty(value = "站点名称")
    private String stationName;

    @ExcelProperty(value = "公司地址")
    private String companyAddress;

    @ExcelProperty(value = "快递点是否存在")
    @ApiModelProperty(value = "站点是否存在(0:未存在,1:已存在)")
    private Integer stationExistStatue;

    //@ApiModelProperty("POI-ID")
    //@ExcelProperty(value = "POI-ID")
    private String poiId;

    //@ExcelProperty(value = "匹配-POI名称")
    //@ApiModelProperty("匹配-POI名称")
    private String poiName;

    //@ApiModelProperty("匹配-POI地址")
    //@ExcelProperty(value = "匹配-POI地址")
    private String poiAddress;

    //@ApiModelProperty("POI编码")
    //@ExcelProperty(value = "")
    private String poiEncode;

    //@ApiModelProperty("POI类型")
    //@ExcelProperty(value = "POI类型")
    private String poiType;

    @ApiModelProperty("标准地址")
    //@ExcelProperty(value = "标准地址")
    private String standardAddress;

    @ExcelProperty(value = "经度")
    private BigDecimal lon;

    @ExcelProperty(value = "纬度")
    private BigDecimal lat;

    @ExcelProperty("勘误状态")
    private Integer kwStatus;

    @ExcelProperty(value = "勘误经度")
    private BigDecimal kwLon;

    @ExcelProperty(value = "勘误纬度")
    private BigDecimal kwLat;

    @ExcelProperty("校对后名称")
    private String kwStationName;

    @ExcelProperty("校对后地址")
    private String kwAddress;

    @ExcelProperty("校对后地址描述")
    private String kwAddressDescribe;

    @ApiModelProperty("勘误类型")
    //@ExcelProperty("勘误类型")
    private Integer kwType;

    @ApiModelProperty("勘误工号")
    //@ExcelProperty(value = "勘误工号")
    private String kwPhone;

    // 这两个属性字段暂时不导入excel
    @ApiModelProperty(value = "info_id")
    @TableField("info_id")
    private String infoId;

    @ApiModelProperty(value = "主表id")
    private String expressProofreadId;

    @ExcelProperty(value = "现有快递点人数")
    @ApiModelProperty(value = "站点人数")
    private Integer stationNum;

    @ExcelProperty(value = "我网客户占比")
    @ApiModelProperty(value = "我网客户占比")
    private String clientProportion;

    @ExcelProperty(value = "快递点联系人")
    @ApiModelProperty(value = "快递点联系人")
    private String stationLinkman;

    @ExcelProperty(value = "联系电话")
    @ApiModelProperty(value = "联系电话")
    private String stationPhone;

    @ExcelProperty(value = "宽带资源是否覆盖")
    @ApiModelProperty(value = "宽带网络资源是否覆盖(0:未覆盖,1:已覆盖)")
    private Integer resourceCoverStatue;

    @ExcelProperty(value = "站长是否协助宣传")
    @ApiModelProperty(value = "站长是否协助宣传(0:否,1:是)")
    private Integer emotionInPlaceStatue;

    @ExcelProperty(value = "是否报销话费")
    @ApiModelProperty(value = "是否报销话费(0:未报销,1:已报销)")
    private String billStatus;

    @ExcelProperty(value = "是否已统一办理号卡")
    @ApiModelProperty(value = "是否已经办理移动卡号(0:未办理,1:已办理)")
    private Integer applyCardStatus;

    @ExcelProperty(value = "未拓展原因(用|隔开)")
    @ApiModelProperty(value = "未拓展原因(用|隔开)")
    private String unextendedReason;

    @ExcelProperty(value = "今年已办卡数")
    @ApiModelProperty(value = "已办卡数量")
    private String cardsNum;

    @ExcelProperty(value = "当月办卡数")
    @ApiModelProperty(value = "月办卡(张)")
    private Integer monthlyCard;

    @ExcelProperty(value = "是否办理骑士卡")
    @ApiModelProperty(value = "办理骑士卡（0：否，1：是）")
    private Integer tsitska;

    @ExcelProperty(value = "套餐(元)")
    @ApiModelProperty(value = "套餐(元)")
    private String comboMoney;

    @ExcelProperty(value = "通话(分钟)")
    @ApiModelProperty(value = "通话(分钟)")
    private Integer communicate;

    @ExcelProperty(value = "通用流量(G)")
    @ApiModelProperty(value = "通用流量(G)")
    private String generalFlux;

    //@ExcelProperty(value = "定向流量(G)")
    @ApiModelProperty(value = "定向流量(G)")
    private String orienteeringFlux;

    //@ExcelProperty(value = "短信(条)")
    @ApiModelProperty(value = "短信(条)")
    private Integer noteNum;

    @ExcelProperty(value = "具体办理号码(用|隔开)")
    //@ApiModelProperty(value = "具体号码列表(用|隔开)")
    private String specificNumber;

    @ExcelProperty(value = "备注说明")
    @ApiModelProperty(value = "备注说明")
    private String stationDescr;

    /*20231007添加字段*/
    @ExcelProperty(value = "归属微网格")
    private String microGridName;

    @ExcelProperty(value = "微网格编码")
    private String microGridId;

    // 20231011添加导入字段
    @ExcelProperty(value = "业务地市")
    private String regionCity;

    @ExcelProperty(value = "业务地市编码")
    private String regionCityCode;


    @ExcelProperty(value = "业务区县")
    private String regionDistricts;


    @ExcelProperty(value = "业务区县编码")
    private String regionDistrictsCode;

    @TableField(exist = false)
    private BigDecimal distance;
}
